A spreadsheet designed to calculate and predict the overall grades of BTEC students according to the value of pass, merit and distinction in the varying units I created this as my students very often ask me about the liklihood of them achieving merit/distinction overall after recieving individual unit grades, and found this easy to illustrate the values of each unit and the impact of them on the overall grade This was designed with Business Studies BTEC Level 3 in mind but can be edited to other subjects using the point values on given specifications on the Pearson website